StoreTenderHistory

Entity Definition

Logical Name : StoreTenderHistory
Physical Name : LE_HST_STR_TND

A collection of tender type accumulators for the store for a REPORTING PERIOD. This entity is used to support store-level tender accountability.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
StoreTenderHistory (FK)(PK) A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. TY_TND Code varchar(20) Tender(AS_TND)
ReportingPeriodID (FK)(PK) The unique system assigned identifier for a particular ReportingPeriod. ID_PRD_RP Identity integer StoreHistory(LE_HST_STR)
RetailStoreID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_STR_RTL Identity integer StoreHistory(LE_HST_STR)
TotalTenderMediaCount The total number of tender media units by RETAIL STORE for each REPORTING PERIOD. QU_MD_TND_TOT QuantityTransactionCount decimal(7,0)
TotalTenderMediaOverCount The total monetary value of tender overages recorded by the RETAIL STORE for each REPORTING PERIOD. QU_MD_TND_OVR_TOT QuantityTransactionCount decimal(7,0)
TotalTenderMediaShortCount The total monetary value of tender shortages recorded by the RETAIL STORE for each REPORTING PERIOD. QU_MD_TND_SHRT_TOT QuantityTransactionCount decimal(7,0)
TotalBeginningTenderMediaUnitCount The opening balance of the number of tender media units recorded by the RETAIL STORE for each REPORTING PERIOD. QU_MD_TND_BGN_TOT QuantityTransactionCount decimal(7,0)
TotalTenderLoanMediaUnitCount The total number of tender loan media units recorded by the RETAIL STORE for each REPORTING PERIOD. QU_MD_TND_LN_TOT QuantityTransactionCount decimal(7,0)
TenderLoanMediaTotalAmount The total monetary value of tender loans recorded by the RETAIL STORE for each REPORTING PERIOD. MO_MD_LON_TND_TOT Money decimal(16,5)
TotalTenderPickupMediaUnitCount The total number of tender pickup media units by the RETAIL STORE for each REPORTING PERIOD. QU_MD_TND_PKP_TOT QuantityTransactionCount decimal(7,0)
TenderPickupMediaTotalAmount The total monetary value of tender pickup recorded by the RETAIL STORE for each REPORTING PERIOD. MO_MD_TND_PKP_TOT Money decimal(16,5)
TenderDepositTotalAmount The total monetary value of tender media deposited by the RETAIL STORE for each REPORTING PERIOD. MO_DS_TND_TOT Money decimal(16,5)
TotalTenderDepositMediaUnitCount The total number of tender media units deposited by the RETAIL STORE for each REPORTING PERIOD. QU_MD_TND_DS_TOT QuantityTransactionCount decimal(7,0)
TenderOverTotalAmount The total monetary value of tender overages recorded by the RETAIL STORE for each REPORTING PERIOD. MO_TND_OVR_TOT Money decimal(16,5)
TenderShortTotalAmount The total monetary value of tender shortages recorded by the RETAIL STORE for each REPORTING PERIOD. MO_TND_SHRT_TOT Money decimal(16,5)

Relationships

Parent Entity Verb Phrase Child Entity
StoreHistory may include StoreTenderHistory
Tender is tracked by StoreTenderHistory

Logical Views containing StoreTenderHistory

Logical View
Logical 03000 - Reporting - Macro View
Logical 03000 - Reporting - Macro View
Logical 03100 - Reporting - Store Operations - Macro View
Logical 03120 - Reporting - Store Operations - Period View